﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_USER_TASK_HISTORY_CLASSIFICATION_UP')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_USER_TASK_HISTORY_CLASSIFICATION_UP
	END

GO

CREATE Procedure dbo.PRC_TB_USER_TASK_HISTORY_CLASSIFICATION_UP
	(
		@TUHC_ID INT,
		@TUHC_DESCRIPTION varchar(150)
	)

AS

UPDATE TB_USER_TASK_HISTORY_CLASSIFICATION
SET TUHC_DESCRIPTION = @TUHC_DESCRIPTION
WHERE TUHC_ID = @TUHC_ID

GO

GRANT EXEC ON dbo.PRC_TB_USER_TASK_HISTORY_CLASSIFICATION_UP TO PUBLIC

GO